package me.zhengjie.sqlservice;

import com.baomidou.mybatisplus.extension.service.IService;
import me.zhengjie.pojo.entity.WcsLineEdgeWarehouse;

import java.util.List;

public interface WcsLineEdgeWarehouseService extends IService<WcsLineEdgeWarehouse> {
    List<WcsLineEdgeWarehouse> selectFloorIdleStatusContainerCodeIsNull(String floor, Integer status);

    boolean updateStatusIsAgv(String storageCode,String containerCode, Integer status, int isAgv);

    boolean updateStatusIsAgv(String storageCode,String containerCode, Integer status, int isAgv,int emptyTrayQuantity);

    List<WcsLineEdgeWarehouse> selectRegionStatusIsNull(String region, Integer status);

    WcsLineEdgeWarehouse selectStorageCode(String storageCode);

    List<WcsLineEdgeWarehouse> selectCcdStatus(Integer ccdStatus);

    boolean updateManualFeeding(Integer id, String containerCode, int status);

    List<WcsLineEdgeWarehouse> selectAll();

    List<WcsLineEdgeWarehouse> selectRegionContainerCodeisNotNull(String region);

    List<WcsLineEdgeWarehouse> selectRegion(String region);

    boolean updateBuzzerStatus(String region, int buzzerStatus);

    List<WcsLineEdgeWarehouse> floorQueryAvailableStorage(String floor);

    List<WcsLineEdgeWarehouse> selectRegionAndStatus(String region, int status);

    List<WcsLineEdgeWarehouse> selectRegionAvailableSize(String region);

    List<WcsLineEdgeWarehouse> selectRegionInStatus(String region, Integer status, Integer status1);

    Integer anomalyAreaGtThreeSize(String region);

    List<WcsLineEdgeWarehouse> selectFloor(String floor);

    boolean updateEmptyTrayQuantityStatus(String storageCode, Integer quantity, Integer status);

    WcsLineEdgeWarehouse selectStorageCodeDoesItExist(String storageCode);

    boolean updateIslocck(String storageCode, Integer isLock);

    List<WcsLineEdgeWarehouse> regionQueryAvailableStorage(String region);

    List<WcsLineEdgeWarehouse> queryAvailableFloor(String floor);

    List<WcsLineEdgeWarehouse> queryRegion(String floor);

    List<WcsLineEdgeWarehouse> deliveryQuereStorageCode(String floor, String region,String destination);

    List<WcsLineEdgeWarehouse> selectRegionAndGeStatus(String region, Integer status);

    List<WcsLineEdgeWarehouse> selectGoodTypeAndStatus(String goodType, int status);

    List<WcsLineEdgeWarehouse> selectGoodTypeInStatus(String goodType, Integer status, Integer status1);
}
